Video: Self JOINs

Self JOINs

Expert Tip

This comes up pretty commonly in job interviews. Self JOIN logic can be pretty tricky -- you can see here that our join has three conditional statements. It is important to pause and think through each step when joining a table to itself.

Quiz: Self JOINS

SOLUTION:

When you want to show both parent and child relationships within a family tree.